[]
        
(Showing Draft Content)

FarPoint.Web.Spread.Chart.SpreadChart.GenerateFromCellRanges

GenerateFromCellRanges Method

GenerateFromCellRanges(SheetView, CellRange, CellRange, CellRange, bool, bool)

Generates a chart from cell ranges.

Declaration
public void GenerateFromCellRanges(SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch, bool autoCreateCategory)
Public Sub GenerateFromCellRanges(sheetView As SheetView, category As CellRange, seriesName As CellRange, data As CellRange, autoSwitch As Boolean, autoCreateCategory As Boolean)
Parameters
Type Name Description
SheetView sheetView

The sheet view.

CellRange category

The category.

CellRange seriesName

Name of the series.

CellRange data

The data.

bool autoSwitch

if set to true, the processing switches the row and column automatically, if necessary.

bool autoCreateCategory

if set to true, the generating process automatically detects and creates the category if the category cell range is NULL.

GenerateFromCellRanges(SheetView, CellRange, CellRange, CellRange, bool)

Generates a chart from cell ranges.

Declaration
public void GenerateFromCellRanges(SheetView sheetView, CellRange category, CellRange seriesName, CellRange data, bool autoSwitch)
Public Sub GenerateFromCellRanges(sheetView As SheetView, category As CellRange, seriesName As CellRange, data As CellRange, autoSwitch As Boolean)
Parameters
Type Name Description
SheetView sheetView

The sheet view.

CellRange category

The category.

CellRange seriesName

Name of the series.

CellRange data

The data.

bool autoSwitch

if set to true, the processing switches rows and columns automatically, if necessary.

GenerateFromCellRanges(SheetView, CellRange[], bool)

Generates a chart from cell ranges.

Declaration
public void GenerateFromCellRanges(SheetView sheetView, CellRange[] cellRanges, bool autoSwitch)
Public Sub GenerateFromCellRanges(sheetView As SheetView, cellRanges As CellRange(), autoSwitch As Boolean)
Parameters
Type Name Description
SheetView sheetView

The sheet view.

CellRange[] cellRanges

The cell ranges.

bool autoSwitch

if set to true, the processing switches rows and columns automatically, if necessary.